<!-- This comment will put IE 6, 7 and 8 in quirks mode -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<title>eCommerce: Plik źródłowy D:/CentrumXP/e-Commerce/eCommerceDev/SklepDAO/PictureDAO.cs</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javaScript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body onload='searchBox.OnSelectItem(0);'>
<!-- Wygenerowano przez Doxygen 1.6.1 -->
<script type="text/javascript"><!--
var searchBox = new SearchBox("searchBox", "search",false,'Szukaj');
--></script>
<div class="navigation" id="top">
  <div class="tabs">
    <ul>
      <li><a href="index.html"><span>Strona&nbsp;główna</span></a></li>
      <li><a href="namespaces.html"><span>Pakiety</span></a></li>
      <li><a href="annotated.html"><span>Klasy</span></a></li>
      <li class="current"><a href="files.html"><span>Pliki</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <img id="MSearchSelect" src="search/search.png"
             onmouseover="return searchBox.OnSearchSelectShow()"
             onmouseout="return searchBox.OnSearchSelectHide()"
             alt=""/>
        <input type="text" id="MSearchField" value="Szukaj" accesskey="S"
             onfocus="searchBox.OnSearchFieldFocus(true)" 
             onblur="searchBox.OnSearchFieldFocus(false)" 
             onkeyup="searchBox.OnSearchFieldChange(event)"/>
        <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
        </div>
      </li>
    </ul>
  </div>
  <div class="tabs">
    <ul>
      <li><a href="files.html"><span>Lista&nbsp;plików</span></a></li>
      <li><a href="globals.html"><span>Składowe&nbsp;plików</span></a></li>
    </ul>
  </div>
<h1>D:/CentrumXP/e-Commerce/eCommerceDev/SklepDAO/PictureDAO.cs</h1><a href="_picture_d_a_o_8cs.html">Idź do dokumentacji tego pliku.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a><a class="code" href="_picture_d_a_o_8cs.html#a81a223a02c34d82b47199f08308847f2">00001</a> ﻿using <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>;
<a name="l00002"></a>00002 <span class="keyword">using</span> <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Collections.Generic;
<a name="l00003"></a>00003 <span class="keyword">using</span> <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.SqlClient;
<a name="l00004"></a>00004 <span class="keyword">using</span> <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data;
<a name="l00005"></a>00005 <span class="keyword">using</span> <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Text;
<a name="l00006"></a>00006 
<a name="l00007"></a>00007 
<a name="l00008"></a>00008 <span class="keyword">using</span> ShopModel;
<a name="l00009"></a>00009 
<a name="l00010"></a>00010 <span class="keyword">namespace </span>ShopDAO
<a name="l00011"></a>00011 {
<a name="l00012"></a><a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html">00012</a>     <span class="keyword">public</span> <span class="keyword">class </span><a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html">PictureDAO</a>
<a name="l00013"></a>00013     {
<a name="l00014"></a>00014         <span class="keyword">private</span> <span class="keywordtype">string</span> connectionString;
<a name="l00015"></a>00015 
<a name="l00016"></a><a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html#a52d0e4c046967c0b18da71de977fae4d">00016</a>         <span class="keyword">public</span> <a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html#a52d0e4c046967c0b18da71de977fae4d">PictureDAO</a>()
<a name="l00017"></a>00017         {
<a name="l00018"></a>00018             connectionString = <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Configuration.ConfigurationManager.ConnectionStrings[<span class="stringliteral">&quot;csShop&quot;</span>].ConnectionString;
<a name="l00019"></a>00019         }
<a name="l00020"></a>00020 
<a name="l00026"></a><a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html#a22a9a606d923946938c6f67409228f01">00026</a>         <span class="keyword">public</span> <span class="keywordtype">bool</span> <a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html#a22a9a606d923946938c6f67409228f01" title="Usuwa pliki zdjęć (Removes picture files from the database).">DeletePicturesFromDataBase</a>(<span class="keywordtype">int</span> productID)
<a name="l00027"></a>00027         {
<a name="l00028"></a>00028             SqlConnection connection = <span class="keyword">new</span> SqlConnection(connectionString);
<a name="l00029"></a>00029             SqlCommand sqlCommand = connection.CreateCommand();
<a name="l00030"></a>00030 
<a name="l00031"></a>00031 
<a name="l00032"></a>00032 
<a name="l00033"></a>00033             sqlCommand.CommandText = <span class="stringliteral">&quot;DeletePicturesFromDataBase&quot;</span>;
<a name="l00034"></a>00034             sqlCommand.CommandType = <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.CommandType.StoredProcedure;
<a name="l00035"></a>00035             sqlCommand.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@productID&quot;</span>, productID));
<a name="l00036"></a>00036 
<a name="l00037"></a>00037             <span class="keywordflow">try</span>
<a name="l00038"></a>00038             {
<a name="l00039"></a>00039                 connection.Open();
<a name="l00040"></a>00040                 sqlCommand.ExecuteNonQuery();
<a name="l00041"></a>00041                 <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00042"></a>00042             }
<a name="l00043"></a>00043             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00044"></a>00044             {
<a name="l00045"></a>00045                 ErrorLogger.LogError(ex);
<a name="l00046"></a>00046                 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00047"></a>00047             }
<a name="l00048"></a>00048             <span class="keywordflow">finally</span>
<a name="l00049"></a>00049             {
<a name="l00050"></a>00050                 connection.Close();
<a name="l00051"></a>00051             }
<a name="l00052"></a>00052             
<a name="l00053"></a>00053         }
<a name="l00054"></a>00054 
<a name="l00060"></a><a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html#adc853cb174485307355afd09335f6587">00060</a>         <span class="keyword">public</span>  <span class="keywordtype">bool</span> <a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html#adc853cb174485307355afd09335f6587" title="Zapisuje plik zdjęcia w bazie danych (Saves photo file in the database.).">SavePicture</a>(ShopModel.PictureInfo picture)
<a name="l00061"></a>00061         {
<a name="l00062"></a>00062             SqlConnection connection = <span class="keyword">new</span> SqlConnection(connectionString);
<a name="l00063"></a>00063             SqlCommand sqlCommand = connection.CreateCommand();
<a name="l00064"></a>00064 
<a name="l00065"></a>00065             sqlCommand.CommandText = <span class="stringliteral">&quot;SavePicture&quot;</span>;
<a name="l00066"></a>00066             sqlCommand.CommandType = <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.CommandType.StoredProcedure;
<a name="l00067"></a>00067 
<a name="l00068"></a>00068             sqlCommand.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@picture_id&quot;</span>, picture.PictureId));
<a name="l00069"></a>00069             sqlCommand.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@name&quot;</span>, picture.Name));
<a name="l00070"></a>00070             sqlCommand.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@is_main&quot;</span>, picture.IsMain));
<a name="l00071"></a>00071             sqlCommand.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@product_id&quot;</span>, picture.ProductId));
<a name="l00072"></a>00072             sqlCommand.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@miniature_id&quot;</span>, picture.Miniature.PictureId));
<a name="l00073"></a>00073             sqlCommand.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@miniature_name&quot;</span>, picture.Miniature.Name));
<a name="l00074"></a>00074 
<a name="l00075"></a>00075             <span class="keywordflow">try</span>
<a name="l00076"></a>00076             {
<a name="l00077"></a>00077                 connection.Open();
<a name="l00078"></a>00078                 sqlCommand.ExecuteNonQuery();
<a name="l00079"></a>00079                 <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00080"></a>00080             }
<a name="l00081"></a>00081             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00082"></a>00082             {
<a name="l00083"></a>00083                 ErrorLogger.LogError(ex);
<a name="l00084"></a>00084                 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00085"></a>00085             }
<a name="l00086"></a>00086             <span class="keywordflow">finally</span>
<a name="l00087"></a>00087             {
<a name="l00088"></a>00088                 connection.Close();
<a name="l00089"></a>00089             }
<a name="l00090"></a>00090         }
<a name="l00091"></a>00091 
<a name="l00097"></a><a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html#aa62a025fa88f0dde00813566f8cc44e2">00097</a>         <span class="keyword">public</span>  List&lt;PictureInfo&gt; <a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html#aa62a025fa88f0dde00813566f8cc44e2" title="Pobiera inforacje o zdjęciach dla produktu o podanym id (Gets information about...">GetPictures</a>(<span class="keywordtype">int</span> productId)
<a name="l00098"></a>00098         {
<a name="l00099"></a>00099             <a class="code" href="class_shop_model_1_1_picture_info.html" title="Klasa przechowująca informacje o zdjeciu dodanym dla produktu (Class storing information...">PictureInfo</a> picture;
<a name="l00100"></a>00100             List&lt;PictureInfo&gt; result = <span class="keyword">new</span> List&lt;PictureInfo&gt;();
<a name="l00101"></a>00101             SqlConnection connection = <span class="keyword">new</span> SqlConnection(connectionString);
<a name="l00102"></a>00102             SqlCommand sqlCommand = connection.CreateCommand();
<a name="l00103"></a>00103 
<a name="l00104"></a>00104 
<a name="l00105"></a>00105 
<a name="l00106"></a>00106             sqlCommand.CommandText = <span class="stringliteral">&quot;PictureForProduct&quot;</span>;
<a name="l00107"></a>00107             sqlCommand.CommandType = <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.CommandType.StoredProcedure;
<a name="l00108"></a>00108             sqlCommand.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@product_id&quot;</span>, productId));
<a name="l00109"></a>00109 
<a name="l00110"></a>00110             <span class="keywordflow">try</span>
<a name="l00111"></a>00111             {
<a name="l00112"></a>00112                 connection.Open();
<a name="l00113"></a>00113                 SqlDataReader reader = sqlCommand.ExecuteReader(<a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.CommandBehavior.CloseConnection);
<a name="l00114"></a>00114 
<a name="l00115"></a>00115                 <span class="keywordflow">while</span> (reader.Read())
<a name="l00116"></a>00116                 {
<a name="l00117"></a>00117                     picture = <span class="keyword">new</span> <a class="code" href="class_shop_model_1_1_picture_info.html" title="Klasa przechowująca informacje o zdjeciu dodanym dla produktu (Class storing information...">PictureInfo</a>();
<a name="l00118"></a>00118                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a34c2e1bc0b4c17922b765e69be75ac61">Miniature</a> = <span class="keyword">new</span> <a class="code" href="class_shop_model_1_1_picture_info.html" title="Klasa przechowująca informacje o zdjeciu dodanym dla produktu (Class storing information...">PictureInfo</a>();
<a name="l00119"></a>00119 
<a name="l00120"></a>00120                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#afd7beb6a1e786a24ea30713ffb5cb672">IsMain</a> = (bool)reader[<span class="stringliteral">&quot;IsMain&quot;</span>];
<a name="l00121"></a>00121                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a7c42f86d5608dfe8bd71710286404da4">Name</a> = reader[<span class="stringliteral">&quot;Name&quot;</span>].ToString();
<a name="l00122"></a>00122                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a4907ffca583ad40736850785870eaf34">PictureId</a> = (int)reader[<span class="stringliteral">&quot;IDpicture&quot;</span>];
<a name="l00123"></a>00123                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a791fb5c66a518a59564475409cf3c517">ProductId</a> = (int)reader[<span class="stringliteral">&quot;ProductID&quot;</span>];
<a name="l00124"></a>00124                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a34c2e1bc0b4c17922b765e69be75ac61">Miniature</a>.<a class="code" href="class_shop_model_1_1_picture_info.html#a7c42f86d5608dfe8bd71710286404da4">Name</a> = reader[<span class="stringliteral">&quot;MiniatureName&quot;</span>].ToString();
<a name="l00125"></a>00125                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a34c2e1bc0b4c17922b765e69be75ac61">Miniature</a>.<a class="code" href="class_shop_model_1_1_picture_info.html#a4907ffca583ad40736850785870eaf34">PictureId</a> = (int)reader[<span class="stringliteral">&quot;MiniatureID&quot;</span>];
<a name="l00126"></a>00126                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a34c2e1bc0b4c17922b765e69be75ac61">Miniature</a>.<a class="code" href="class_shop_model_1_1_picture_info.html#a791fb5c66a518a59564475409cf3c517">ProductId</a> = (int)reader[<span class="stringliteral">&quot;ProductID&quot;</span>];
<a name="l00127"></a>00127 
<a name="l00128"></a>00128                     result.Add(picture);
<a name="l00129"></a>00129                 }
<a name="l00130"></a>00130                 reader.Close();
<a name="l00131"></a>00131 
<a name="l00132"></a>00132                 <span class="keywordflow">return</span> result;
<a name="l00133"></a>00133             }
<a name="l00134"></a>00134             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00135"></a>00135             {
<a name="l00136"></a>00136                 ErrorLogger.LogError(ex);
<a name="l00137"></a>00137                 <span class="keywordflow">return</span> null;
<a name="l00138"></a>00138             }
<a name="l00139"></a>00139             <span class="keywordflow">finally</span>
<a name="l00140"></a>00140             {
<a name="l00141"></a>00141                 connection.Close();
<a name="l00142"></a>00142             }
<a name="l00143"></a>00143         }
<a name="l00144"></a>00144 
<a name="l00150"></a><a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html#ad2c8a5f352f5d40d4ec146d8dc46cfcf">00150</a>         <span class="keyword">public</span>  <span class="keywordtype">bool</span> <a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html#ad2c8a5f352f5d40d4ec146d8dc46cfcf" title="Usuwa zdjęci o podanym id (Removes photos for the product with given id.).">RemovePicture</a>(<span class="keywordtype">int</span> pictureId)
<a name="l00151"></a>00151         {
<a name="l00152"></a>00152             SqlConnection connection = <span class="keyword">new</span> SqlConnection(connectionString);
<a name="l00153"></a>00153             SqlCommand sqlCommand = connection.CreateCommand();
<a name="l00154"></a>00154 
<a name="l00155"></a>00155             sqlCommand.CommandText = <span class="stringliteral">&quot;RemovePicture&quot;</span>;
<a name="l00156"></a>00156             sqlCommand.CommandType = <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.CommandType.StoredProcedure;
<a name="l00157"></a>00157 
<a name="l00158"></a>00158             sqlCommand.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@picture_id&quot;</span>, pictureId));
<a name="l00159"></a>00159 
<a name="l00160"></a>00160             <span class="keywordflow">try</span>
<a name="l00161"></a>00161             {
<a name="l00162"></a>00162                 connection.Open();
<a name="l00163"></a>00163                 sqlCommand.ExecuteNonQuery();
<a name="l00164"></a>00164                 <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00165"></a>00165             }
<a name="l00166"></a>00166             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00167"></a>00167             {
<a name="l00168"></a>00168                 ErrorLogger.LogError(ex);
<a name="l00169"></a>00169                 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00170"></a>00170             }
<a name="l00171"></a>00171             <span class="keywordflow">finally</span>
<a name="l00172"></a>00172             {
<a name="l00173"></a>00173                 connection.Close();
<a name="l00174"></a>00174             }
<a name="l00175"></a>00175         }
<a name="l00176"></a>00176 
<a name="l00182"></a><a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html#ae8948893e10cddafd21f83155665fb43">00182</a>         <span class="keyword">public</span>  <span class="keywordtype">bool</span> <a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html#ae8948893e10cddafd21f83155665fb43" title="Ustaw zdjęcie o podanym id jako główne (Sets as main photo, picture with given...">SetAsMainPicture</a>(<span class="keywordtype">int</span> pictureId)
<a name="l00183"></a>00183         {
<a name="l00184"></a>00184             SqlConnection connection = <span class="keyword">new</span> SqlConnection(connectionString);
<a name="l00185"></a>00185             SqlCommand sqlCommand = connection.CreateCommand();
<a name="l00186"></a>00186 
<a name="l00187"></a>00187             sqlCommand.CommandText = <span class="stringliteral">&quot;SetAsMainPicture&quot;</span>;
<a name="l00188"></a>00188             sqlCommand.CommandType = <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.CommandType.StoredProcedure;
<a name="l00189"></a>00189 
<a name="l00190"></a>00190             sqlCommand.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@picture_id&quot;</span>, pictureId));
<a name="l00191"></a>00191 
<a name="l00192"></a>00192             <span class="keywordflow">try</span>
<a name="l00193"></a>00193             {
<a name="l00194"></a>00194                 connection.Open();
<a name="l00195"></a>00195                 sqlCommand.ExecuteNonQuery();
<a name="l00196"></a>00196                 <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00197"></a>00197             }
<a name="l00198"></a>00198             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00199"></a>00199             {
<a name="l00200"></a>00200                 ErrorLogger.LogError(ex);
<a name="l00201"></a>00201                 <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00202"></a>00202             }
<a name="l00203"></a>00203             <span class="keywordflow">finally</span>
<a name="l00204"></a>00204             {
<a name="l00205"></a>00205                 connection.Close();
<a name="l00206"></a>00206             }
<a name="l00207"></a>00207         }
<a name="l00208"></a>00208 
<a name="l00214"></a><a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html#af0eb063e9fc93715df647df3e32020b1">00214</a>         <span class="keyword">public</span>  <a class="code" href="class_shop_model_1_1_picture_info.html" title="Klasa przechowująca informacje o zdjeciu dodanym dla produktu (Class storing information...">PictureInfo</a> <a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html#af0eb063e9fc93715df647df3e32020b1" title="Pobiera informacje dla zdjęcia o podanym id(Downloads information about photos with...">GetPicture</a>(<span class="keywordtype">int</span> pictureId)
<a name="l00215"></a>00215         {
<a name="l00216"></a>00216             <a class="code" href="class_shop_model_1_1_picture_info.html" title="Klasa przechowująca informacje o zdjeciu dodanym dla produktu (Class storing information...">PictureInfo</a> picture = <span class="keyword">new</span> <a class="code" href="class_shop_model_1_1_picture_info.html" title="Klasa przechowująca informacje o zdjeciu dodanym dla produktu (Class storing information...">PictureInfo</a>();
<a name="l00217"></a>00217             SqlConnection connection = <span class="keyword">new</span> SqlConnection(connectionString);
<a name="l00218"></a>00218             SqlCommand sqlCommand = connection.CreateCommand();
<a name="l00219"></a>00219 
<a name="l00220"></a>00220 
<a name="l00221"></a>00221 
<a name="l00222"></a>00222             sqlCommand.CommandText = <span class="stringliteral">&quot;PictureById&quot;</span>;
<a name="l00223"></a>00223             sqlCommand.CommandType = <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.CommandType.StoredProcedure;
<a name="l00224"></a>00224             sqlCommand.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@product_id&quot;</span>, pictureId));
<a name="l00225"></a>00225 
<a name="l00226"></a>00226 
<a name="l00227"></a>00227             <span class="comment">//SqlDataReader sqlR = sqlCommand.ExecuteReader();</span>
<a name="l00228"></a>00228             <span class="keywordflow">try</span>
<a name="l00229"></a>00229             {
<a name="l00230"></a>00230                 connection.Open();
<a name="l00231"></a>00231                 SqlDataReader reader = sqlCommand.ExecuteReader(<a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.CommandBehavior.CloseConnection);
<a name="l00232"></a>00232 
<a name="l00233"></a>00233                 <span class="keywordflow">if</span> (reader.Read())
<a name="l00234"></a>00234                 {
<a name="l00235"></a>00235                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a34c2e1bc0b4c17922b765e69be75ac61">Miniature</a> = <span class="keyword">new</span> <a class="code" href="class_shop_model_1_1_picture_info.html" title="Klasa przechowująca informacje o zdjeciu dodanym dla produktu (Class storing information...">PictureInfo</a>();
<a name="l00236"></a>00236 
<a name="l00237"></a>00237                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#afd7beb6a1e786a24ea30713ffb5cb672">IsMain</a> = (bool)reader[<span class="stringliteral">&quot;IsMain&quot;</span>];
<a name="l00238"></a>00238                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a7c42f86d5608dfe8bd71710286404da4">Name</a> = reader[<span class="stringliteral">&quot;Name&quot;</span>].ToString();
<a name="l00239"></a>00239                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a4907ffca583ad40736850785870eaf34">PictureId</a> = (int)reader[<span class="stringliteral">&quot;IDpicture&quot;</span>];
<a name="l00240"></a>00240                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a791fb5c66a518a59564475409cf3c517">ProductId</a> = (int)reader[<span class="stringliteral">&quot;ProductID&quot;</span>];
<a name="l00241"></a>00241                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a34c2e1bc0b4c17922b765e69be75ac61">Miniature</a>.<a class="code" href="class_shop_model_1_1_picture_info.html#a7c42f86d5608dfe8bd71710286404da4">Name</a> = reader[<span class="stringliteral">&quot;MiniatureName&quot;</span>] != DBNull.Value ? reader[<span class="stringliteral">&quot;MiniatureName&quot;</span>].ToString() : <span class="keywordtype">string</span>.Empty;
<a name="l00242"></a>00242                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a34c2e1bc0b4c17922b765e69be75ac61">Miniature</a>.<a class="code" href="class_shop_model_1_1_picture_info.html#a4907ffca583ad40736850785870eaf34">PictureId</a> = reader[<span class="stringliteral">&quot;MiniatureID&quot;</span>] != DBNull.Value ? (int)reader[<span class="stringliteral">&quot;MiniatureID&quot;</span>] : -1;
<a name="l00243"></a>00243                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a34c2e1bc0b4c17922b765e69be75ac61">Miniature</a>.<a class="code" href="class_shop_model_1_1_picture_info.html#a791fb5c66a518a59564475409cf3c517">ProductId</a> = reader[<span class="stringliteral">&quot;ProductID&quot;</span>] != DBNull.Value ? (int)reader[<span class="stringliteral">&quot;ProductID&quot;</span>] : -1;
<a name="l00244"></a>00244                 }
<a name="l00245"></a>00245 
<a name="l00246"></a>00246                 reader.Close();
<a name="l00247"></a>00247 
<a name="l00248"></a>00248             }
<a name="l00249"></a>00249             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00250"></a>00250             {
<a name="l00251"></a>00251                 ErrorLogger.LogError(ex); 
<a name="l00252"></a>00252             }
<a name="l00253"></a>00253             <span class="keywordflow">finally</span>
<a name="l00254"></a>00254             {
<a name="l00255"></a>00255                 connection.Close();
<a name="l00256"></a>00256             }
<a name="l00257"></a>00257             <span class="keywordflow">return</span> picture;
<a name="l00258"></a>00258 
<a name="l00259"></a>00259         }
<a name="l00260"></a>00260 
<a name="l00266"></a><a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html#af4c203a17c9051399a6d5ad51b65c8f5">00266</a>         <span class="keyword">public</span>  <a class="code" href="class_shop_model_1_1_picture_info.html" title="Klasa przechowująca informacje o zdjeciu dodanym dla produktu (Class storing information...">PictureInfo</a> <a class="code" href="class_shop_d_a_o_1_1_picture_d_a_o.html#af4c203a17c9051399a6d5ad51b65c8f5" title="Pobiera głowne djęcie dla produktu o podanym id (Gets main photo for the chosen...">MainPictureForProduct</a>(<span class="keywordtype">int</span> productId)
<a name="l00267"></a>00267         {
<a name="l00268"></a>00268             <a class="code" href="class_shop_model_1_1_picture_info.html" title="Klasa przechowująca informacje o zdjeciu dodanym dla produktu (Class storing information...">PictureInfo</a> picture = <span class="keyword">new</span> <a class="code" href="class_shop_model_1_1_picture_info.html" title="Klasa przechowująca informacje o zdjeciu dodanym dla produktu (Class storing information...">PictureInfo</a>();
<a name="l00269"></a>00269             picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a34c2e1bc0b4c17922b765e69be75ac61">Miniature</a> = <span class="keyword">new</span> <a class="code" href="class_shop_model_1_1_picture_info.html" title="Klasa przechowująca informacje o zdjeciu dodanym dla produktu (Class storing information...">PictureInfo</a>();
<a name="l00270"></a>00270 
<a name="l00271"></a>00271             SqlConnection connection = <span class="keyword">new</span> SqlConnection(connectionString);
<a name="l00272"></a>00272             SqlCommand sqlCommand = connection.CreateCommand();
<a name="l00273"></a>00273 
<a name="l00274"></a>00274 
<a name="l00275"></a>00275 
<a name="l00276"></a>00276             sqlCommand.CommandText = <span class="stringliteral">&quot;MainPictureForProduct&quot;</span>;
<a name="l00277"></a>00277             sqlCommand.CommandType = <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.CommandType.StoredProcedure;
<a name="l00278"></a>00278             sqlCommand.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@product_id&quot;</span>, productId));
<a name="l00279"></a>00279 
<a name="l00280"></a>00280             <span class="keywordflow">try</span>
<a name="l00281"></a>00281             {
<a name="l00282"></a>00282                 connection.Open();
<a name="l00283"></a>00283                 SqlDataReader reader = sqlCommand.ExecuteReader(<a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.CommandBehavior.CloseConnection);
<a name="l00284"></a>00284 
<a name="l00285"></a>00285                 <span class="keywordflow">if</span> (reader.Read())
<a name="l00286"></a>00286                 {
<a name="l00287"></a>00287                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#afd7beb6a1e786a24ea30713ffb5cb672">IsMain</a> = (bool)reader[<span class="stringliteral">&quot;IsMain&quot;</span>];
<a name="l00288"></a>00288                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a7c42f86d5608dfe8bd71710286404da4">Name</a> = reader[<span class="stringliteral">&quot;Name&quot;</span>].ToString();
<a name="l00289"></a>00289                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a4907ffca583ad40736850785870eaf34">PictureId</a> = (int)reader[<span class="stringliteral">&quot;IDpicture&quot;</span>];
<a name="l00290"></a>00290                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a791fb5c66a518a59564475409cf3c517">ProductId</a> = (int)reader[<span class="stringliteral">&quot;ProductID&quot;</span>];
<a name="l00291"></a>00291                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a34c2e1bc0b4c17922b765e69be75ac61">Miniature</a>.<a class="code" href="class_shop_model_1_1_picture_info.html#a7c42f86d5608dfe8bd71710286404da4">Name</a> = reader[<span class="stringliteral">&quot;MiniatureName&quot;</span>].ToString();
<a name="l00292"></a>00292                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a34c2e1bc0b4c17922b765e69be75ac61">Miniature</a>.<a class="code" href="class_shop_model_1_1_picture_info.html#a4907ffca583ad40736850785870eaf34">PictureId</a> = (int)reader[<span class="stringliteral">&quot;MiniatureID&quot;</span>];
<a name="l00293"></a>00293                     picture.<a class="code" href="class_shop_model_1_1_picture_info.html#a34c2e1bc0b4c17922b765e69be75ac61">Miniature</a>.<a class="code" href="class_shop_model_1_1_picture_info.html#a791fb5c66a518a59564475409cf3c517">ProductId</a> = (int)reader[<span class="stringliteral">&quot;ProductID&quot;</span>];
<a name="l00294"></a>00294 
<a name="l00295"></a>00295                     reader.Close();
<a name="l00296"></a>00296                     <span class="keywordflow">return</span> picture;
<a name="l00297"></a>00297                 }
<a name="l00298"></a>00298                 <span class="keywordflow">else</span>
<a name="l00299"></a>00299                 {
<a name="l00300"></a>00300                     reader.Close();
<a name="l00301"></a>00301                     <span class="keywordflow">return</span> null;
<a name="l00302"></a>00302                 }
<a name="l00303"></a>00303             }
<a name="l00304"></a>00304             <span class="keywordflow">catch</span> (Exception ex)
<a name="l00305"></a>00305             {
<a name="l00306"></a>00306                 ErrorLogger.LogError(ex);
<a name="l00307"></a>00307                 <span class="keywordflow">return</span> null;
<a name="l00308"></a>00308             }
<a name="l00309"></a>00309             <span class="keywordflow">finally</span>
<a name="l00310"></a>00310             {
<a name="l00311"></a>00311                 connection.Close();
<a name="l00312"></a>00312             }
<a name="l00313"></a>00313         }
<a name="l00314"></a>00314     }
<a name="l00315"></a>00315 }
</pre></div></div>
<!--- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&nbsp;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&nbsp;</span>Klasy</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&nbsp;</span>Przestrzenie nazw</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&nbsp;</span>Pliki</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&nbsp;</span>Funkcje</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark">&nbsp;</span>Zmienne</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark">&nbsp;</span>Wyliczenia</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(7)"><span class="SelectionMark">&nbsp;</span>Właściwości</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(8)"><span class="SelectionMark">&nbsp;</span>Zdarzenia</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<hr size="1"/><address style="text-align: right;"><small>Wygenerowano Mon Nov 9 06:08:17 2009 dla eCommerce programem&nbsp;
<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.6.1 </small></address>
</body>
</html>
